How to: Use the RAND() function.
Solution:
Select the desired cell. Enter =RAND(). Press F9 to generate new random numbers.
NOTE: The RAND() function generates a random decimal number between 0 and 1.
1) Select the cell where the result of the RAND() function is to be displayed.
2) Type = (an equal sign) and the RAND command:
=RAND()
NOTE: The RAND() function does not require arguments between the parentheses.
3) Press ENTER.
NOTE: Press F9 to produce a new random decimal number.
